ViewDataAction.java

/*
 *                 Sun Public License Notice
 * 
 * The contents of this file are subject to the Sun Public License
 * Version 1.0 (the "License"). You may not use this file except in
 * compliance with the License. A copy of the License is available at
 * http://www.sun.com/
 * 
 * The Original Code is NetBeans. The Initial Developer of the Original
 * Code is Sun Microsystems, Inc. Portions Copyright 1997-2001 Sun
 * Microsystems, Inc. All Rights Reserved.
 */

package org.netbeans.modules.db.explorer.actions;

import java.util.*;
//import java.sql.Connection;
import org.openide.*;
import org.openide.nodes.*;
import org.openide.util.NbBundle;

import org.netbeans.modules.db.explorer.nodes.*;
import org.netbeans.modules.db.explorer.infos.*;
import org.netbeans.modules.db.explorer.dataview.*;

public class ViewDataAction extends DatabaseAction
{
    static final long serialVersionUID =-894644054833609687L;
    protected boolean enable(Node[] activatedNodes)
    {
        Node node;
        if (activatedNodes != null && activatedNodes.length>0) node = activatedNodes[0];
        else return false;

        ConnectionNodeInfo info = (ConnectionNodeInfo)node.getCookie(ConnectionNodeInfo.class);
        if (info != null) return (info.getConnection() != null);
        return true;
    }

    public void performAction (Node[] activatedNodes)
    {
        String expression = "";
        StringBuffer cols = new StringBuffer();
        Node node;
        ResourceBundle bundle = NbBundle.getBundle("org.netbeans.modules.db.resources.Bundle");

        if (activatedNodes != null && activatedNodes.length>0) {
            try {

                node = activatedNodes[0];
                DatabaseNodeInfo info = (DatabaseNodeInfo)node.getCookie(DatabaseNodeInfo.class);
                String onome = info.getName();
                if (info instanceof TableNodeInfo || info instanceof ViewNodeInfo) {
                    Enumeration enum = info.getChildren().elements();
                    while (enum.hasMoreElements()) {
                        DatabaseNodeInfo nfo = (DatabaseNodeInfo)enum.nextElement();
                        if (nfo instanceof ColumnNodeInfo || nfo instanceof ViewColumnNodeInfo) {
                            if (cols.length()>0) cols.append(", ");
                            cols.append(nfo.getName());
                        }
                    }

                    expression = "select "+cols.toString()+" from "+onome;

                } else if (info instanceof ColumnNodeInfo || info instanceof ViewColumnNodeInfo) {
                    onome = info.getTable();
                    for (int i = 0; i<activatedNodes.length; i++) {
                        node = activatedNodes[i];
                        info = (DatabaseNodeInfo)node.getCookie(DatabaseNodeInfo.class);
                        if (info instanceof ColumnNodeInfo || info instanceof ViewColumnNodeInfo) {
                            if (cols.length()>0) cols.append(", ");
                            cols.append(info.getName());
                        }
                    }

                    expression = "select "+cols.toString()+" from "+onome;

                }

                DataViewWindow win = new DataViewWindow(info, expression);
                win.open();
                win.executeCommand();
            } catch(Exception e) {
                TopManager.getDefault().notify(new NotifyDescriptor.Message(bundle.getString("ShowDataError") + e.getMessage(), NotifyDescriptor.ERROR_MESSAGE));
            }
        }
    }
}
/*
 * <<Log>>
 *  8    Gandalf-post-FCS1.6.1.0     4/10/00  Radko Najman    
 *  7    Gandalf   1.6         2/10/00  Radko Najman    
 *  6    Gandalf   1.5         11/27/99 Patrik Knakal   
 *  5    Gandalf   1.4         10/23/99 Ian Formanek    NO SEMANTIC CHANGE - Sun
 *       Microsystems Copyright in File Comment
 *  4    Gandalf   1.3         9/8/99   Slavek Psenicka adaptor changes
 *  3    Gandalf   1.2         7/21/99  Slavek Psenicka 
 *  2    Gandalf   1.1         6/9/99   Ian Formanek    ---- Package Change To 
 *       org.openide ----
 *  1    Gandalf   1.0         5/21/99  Slavek Psenicka 
 * $
 */